Click Here!
home account info subscribe login search My ITKnowledge FAQ/help site map contact us


 
Brief Full
 Advanced
      Search
 Search Tips
To access the contents, click the chapter and section titles.

Oracle Performance Tuning and Optimization
(Publisher: Macmillan Computer Publishing)
Author(s): Edward Whalen
ISBN: 067230886x
Publication Date: 04/01/96

Bookmark It

Search this book:
 
Previous Table of Contents Next


Analysis Tools

Several analysis tools available from Oracle and third parties are useful in tracking down inefficiencies and bottlenecks in SQL statements. These tools work both on the client machines and on the server itself. These analysis tools can assist you in tracking down a particular SQL statement that is causing problems or can point to a particular table or cluster that is inefficient.

Two of the Oracle tools—Oracle Expert and Oracle Trace—are part of the new Oracle Mission Control console. Oracle Mission Control is a graphical console designed to assist you in monitoring, managing, and tuning your Oracle systems.

Oracle Expert is designed to look for and correct system bottlenecks. Oracle has recently introduced the Oracle Trace product, which originated with Digital RDB. Oracle Trace can be used in a manner similar to SQL Trace and can be extended to the network and applications.

Third-party tools are also available to analyze SQL statements and performance; these include tools from Platinum Technologies, Precise Software Solutions, Compuware, Eventus, and BMC. The following sections look at some of the analysis tools currently available.

Oracle Mission Control

Oracle’s Mission Control console is a graphical management station that includes some of the following features:

  Monitoring and Alerting. This feature allows for threshold monitoring and event management, which can consist of paging a DBA or performing an automatic corrective action.
  Automated Task Scheduling. Automated maintenance tasks can be scheduled and run during off-hours, unattended.
  Monitoring and Diagnostics. This feature can allow the database administrator to trace connections and diagnose problems in real time.
  SNMP Monitoring. The Oracle Mission Control console provides SNMP information to third-party management consoles.
  Tuning. When you use Oracle Expert, tuning can be assisted by the expert system.
  Whole System Monitoring. This feature allows you to monitor your entire environment from a single console.

Oracle Trace

Oracle Trace is a new product based on technology acquired when Oracle purchased the RDB product from Digital Equipment Corporation. Oracle Trace take SQL Trace to client/server computing.


NOTE:  Oracle Trace is the product name for the new client/server trace facility. Although it is similar in function, it should not be confused with SQL Trace.

Oracle Trace begins where SQL Trace left off. The key feature of Oracle Trace is its ability to monitor applications and third-party tools using the SQL Trace function. Oracle Trace collects performance data on predefined events in the Oracle Server, SQL*Net, Oracle Forms, or any third-party application that has been written to take advantage of Oracle Trace.

Oracle Trace provides information similar to the data you expect from SQL Trace:

  CPU time
  Memory usage
  Page faults
  Other user-defined data

By allowing you to define your own data to monitor—as either an end user or an applications developer—this tool offers tremendous flexibility. Oracle Trace information can be viewed with the Oracle Mission Control console and will soon be available in third-party performance-monitoring tools. By tracing your application from the client, through the network, and to the server, performance bottlenecks can more easily be detected and removed.

Third-Party Tools

A number of fine products are on the market today, designed to help you analyze your system, determine bottlenecks, and remove those bottlenecks. Some of these tools are general; others focus on a specific area. The following sections take a sampling of the various tools that serve different purposes.


NOTE:  Many tools are available on the market; the fact that I have chosen just a few is not an endorsement of a particular product. Because products are constantly being introduced and improved, I have decided to focus on the products with which I am most familiar. Because there are many great products I have not mentioned, I suggest that you look at the market before purchasing an analysis tool.


Previous Table of Contents Next


Products |  Contact Us |  About Us |  Privacy  |  Ad Info  |  Home

Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc.
All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited.